home *** CD-ROM | disk | FTP | other *** search
- Summary of corrections to "Running Microsoft Access" and the
- PROMPT.MDB database as of 1/24/93.
-
- Chapter 12, Page 270, line 2
- should read: "... or choose the Select Form command from the
- Edit menu)"
-
-
- Chapter 14, Page 312, "Adding Calculated Values"
- To properly display totals when some months have no sales for
- a particular item, the formula should read:
- =IIf(IsNull([Jan]),0,[Jan]) +IIf(IsNull([Feb]),0,[Feb])
- +IIf(IsNull([Mar]),0,[Mar])
-
-
- Chapter 19, Pages 424-426, "Orders Form Properties" and
- "Picking a Customer on the Orders Form"
- Although setting Allow Updating to Any Tables does let you update
- customer information on the "one" side of the query as documented,
- it also has the unwanted side effect of attempting to delete the
- customer row when you try to delete an order. This works OK when
- you are deleting the last order for a customer (but the customer
- row disappears!), but generates an error if the customer still has
- orders outstanding. The sample database has been changed to set
- Allow Updating to Default Tables. The desired update to customer
- information is accomplished with unbound controls and additional
- macro routines in the Orders macro.
-
- Chapter 19, Page 409, Figure 19-12
- The setting for the Item argument in the second SetValue should
- read: Forms![Catalog - Chap 14]![Price]
-
- Chapter 19, Page 411, Figure 19-15
- The setting for the SQL Statement argument in the RunSQL action
- should read:
- DELETE DISTINCTROW [Item Components].[Catalog Item ID]
- FROM [Item Components] WHERE [Item Components].[Catalog Item ID] =
- Forms![Catalog - Chap 14]![Catalog Item ID];
-
- Chapter 19, Page 411, paragraph immediately under Figure 19-15
- should begin:
- "Notice that the Condition argument in the first Action of the
- Delete Items macro uses ..."
-
- Chapter 19, Page 430, Figure 19-39
- The setting for the Macro Name argument in the RunMacro action
- should read:
- Orders - Chap 19.Calc Tax
-
-
-
- Improvements to PROMPT.MDB:
-
- OnDelete macros have been added to all forms in the application to
- trap all possible referential integrity violations and display a
- more informative message box or take appropriate cascading delete
- action.
-
- A macro has been added to BeforeUpdate of the Display / Add Components
- form to cause any change in Our Cost to also be reflected in any
- related rows in the Catalog Items table.